Rows to Update

This property box determines which rows the Update Data activity will update.

Note: You must configure the Data Source property box before configuring this property box.

To configure Rows to Update

1. Add the Update Data activity to your workflow definition by dragging it from the Toolbox Pane and dropping it in the Designer Pane.
2. Select the activity in the Designer Pane.
3. Under Rows to Update in the Properties Pane, select the table you want to update from the drop-down menu.



To update a row

1. Click Add in the Rows to Update property box to find the row(s) you want to update.
2. In the Add Update Criteria dialog box, select the column you want use to find the rows you want to update from the drop-down menu.



3. Type in the value a row must have in order to update that row, or click the Token button (right arrow) to use tokens.
4. Click OK.

To edit an added row

1. To change the query value for a column, click an existing query.
2. Click Edit.
3. In the Edit Update Criteria dialog box, modify in the value a row must have in order to update that row. Click the Token button (right arrow) to use tokens.
4. Click OK.

To remove an added row

• Click an existing query.
• Click Remove.